# -- coding: utf-8 --
# @Time : 2022-3-3 11:32
# @Author : huabao.tan
# @File : config.py


from power.db.query_mysql import *
from tool.allFunction.Function import *

c = SqlNameCode()


def get_rows_data(sheetname, row):
    wb = openpyxl.load_workbook(r'C:\Users\huabao.tan.CORP\Desktop\国网\国网二期\导入Excel\02-个人考评报告生成.xlsx')
    sheet = wb[sheetname]
    row_list = []
    for a in sheet[row]:
        row_list.append(a.value)
    return row_list


LIST = get_rows_data('1-反馈对象', 1)
LIST2 = get_rows_data('2-个人近三年比较', 1)


name = c.result()[1]
code = c.result()[0]
print(name)
print(code)




